--
-- PostgreSQL database dump
--

-- Dumped from database version 17.4
-- Dumped by pg_dump version 17.4

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: checkout_cart(integer, integer[]); Type: PROCEDURE; Schema: public; Owner: postgres
--

CREATE PROCEDURE public.checkout_cart(IN buyer_id integer, IN equipment_ids integer[], OUT success boolean, OUT message text)
    LANGUAGE plpgsql
    AS $$
    DECLARE
        total_price NUMERIC(10,2) := 0;
        current_balance NUMERIC(10,2);
        equip_record RECORD;
        trans_id INT;
    BEGIN
        -- 获取用户余额
        SELECT Balance INTO current_balance FROM Users WHERE UserID = buyer_id;
        
        -- 计算总价并检查装备状态
        FOR equip_record IN 
            SELECT e.EquipmentID, e.Price, e.SellerID, e.Status
            FROM Equipments e
            WHERE e.EquipmentID = ANY(equipment_ids)
        LOOP
            IF equip_record.Status != 'active' THEN
                success := FALSE;
                message := '装备状态不可购买: ' || equip_record.EquipmentID;
                RETURN;
            END IF;
            
            total_price := total_price + equip_record.Price;
        END LOOP;
        
        -- 检查余额
        IF current_balance < total_price THEN
            success := FALSE;
            message := '余额不足，需要: ' || total_price || '，当前余额: ' || current_balance;
            RETURN;
        END IF;
        
        -- 处理每个装备的交易
        FOR equip_record IN 
            SELECT e.EquipmentID, e.Price, e.SellerID
            FROM Equipments e
            WHERE e.EquipmentID = ANY(equipment_ids)
        LOOP
            -- 创建交易记录
            INSERT INTO Transactions
                (EquipmentID, SellerID, BuyerID, TransactionDate, Price, Status)
            VALUES 
                (equip_record.EquipmentID, equip_record.SellerID, buyer_id, NOW(), equip_record.Price, 'completed')
            RETURNING TransactionID INTO trans_id;
        END LOOP;
        
        success := TRUE;
        message := '结算成功，总金额: ' || total_price;
    EXCEPTION
        WHEN OTHERS THEN
            success := FALSE;
            message := '结算失败: ' || SQLERRM;
    END;
    $$;


ALTER PROCEDURE public.checkout_cart(IN buyer_id integer, IN equipment_ids integer[], OUT success boolean, OUT message text) OWNER TO postgres;

--
-- Name: deposit_funds(integer, numeric); Type: PROCEDURE; Schema: public; Owner: postgres
--

CREATE PROCEDURE public.deposit_funds(IN user_id integer, IN amount numeric, OUT success boolean, OUT message text)
    LANGUAGE plpgsql
    AS $$
    DECLARE
        new_balance NUMERIC(10,2);
    BEGIN
        IF amount <= 0 THEN
            success := FALSE;
            message := '充值金额必须大于0';
            RETURN;
        END IF;
        
        -- 更新余额
        UPDATE Users 
        SET Balance = Balance + amount 
        WHERE UserID = user_id
        RETURNING Balance INTO new_balance;
        
        -- 创建流水记录
        INSERT INTO WalletRecords
            (UserID, Type, Amount, Balance, Timestamp)
        VALUES 
            (user_id, 'deposit', amount, new_balance, NOW());
        
        success := TRUE;
        message := '充值成功，当前余额: ' || new_balance;
    EXCEPTION
        WHEN OTHERS THEN
            success := FALSE;
            message := '充值失败: ' || SQLERRM;
    END;
    $$;


ALTER PROCEDURE public.deposit_funds(IN user_id integer, IN amount numeric, OUT success boolean, OUT message text) OWNER TO postgres;

--
-- Name: generate_transaction_report(timestamp without time zone, timestamp without time zone); Type: PROCEDURE; Schema: public; Owner: postgres
--

CREATE PROCEDURE public.generate_transaction_report(IN start_date timestamp without time zone, IN end_date timestamp without time zone, OUT transaction_count integer, OUT total_amount numeric)
    LANGUAGE plpgsql
    AS $$
    DECLARE
        cur CURSOR FOR 
            SELECT t.TransactionID, t.Price
            FROM Transactions t
            WHERE t.TransactionDate BETWEEN start_date AND end_date
              AND t.Status = 'completed'
            ORDER BY t.TransactionDate;
        
        rec RECORD;
    BEGIN
        transaction_count := 0;
        total_amount := 0;
        
        OPEN cur;
        
        LOOP
            FETCH cur INTO rec;
            EXIT WHEN NOT FOUND;
            
            transaction_count := transaction_count + 1;
            total_amount := total_amount + rec.Price;
        END LOOP;
        
        CLOSE cur;
    EXCEPTION
        WHEN OTHERS THEN
            RAISE NOTICE '生成报表失败: %', SQLERRM;
    END;
    $$;


ALTER PROCEDURE public.generate_transaction_report(IN start_date timestamp without time zone, IN end_date timestamp without time zone, OUT transaction_count integer, OUT total_amount numeric) OWNER TO postgres;

--
-- Name: price_change_notify(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.price_change_notify() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    BEGIN
        IF OLD.Price != NEW.Price THEN
            INSERT INTO PriceChangeMessages (UserID, EquipmentID, OldPrice, NewPrice, ChangeDate, IsRead)
            SELECT c.UserID, NEW.EquipmentID, OLD.Price, NEW.Price, NOW(), FALSE
            FROM Cart c
            WHERE c.EquipmentID = NEW.EquipmentID AND c.UserID != NEW.SellerID;
        END IF;
        RETURN NEW;
    END;
    $$;


ALTER FUNCTION public.price_change_notify() OWNER TO postgres;

--
-- Name: process_completed_transaction(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.process_completed_transaction() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    DECLARE
        buyer_balance NUMERIC(10,2);
        seller_balance NUMERIC(10,2);
    BEGIN
        -- 更新装备状态为已售出
        UPDATE Equipments 
        SET Status = 'sold' 
        WHERE EquipmentID = NEW.EquipmentID;
        
        -- 买家扣款
        UPDATE Users 
        SET Balance = Balance - NEW.Price 
        WHERE UserID = NEW.BuyerID
        RETURNING Balance INTO buyer_balance;
        
        -- 卖家收款
        UPDATE Users 
        SET Balance = Balance + NEW.Price 
        WHERE UserID = NEW.SellerID
        RETURNING Balance INTO seller_balance;
        
        -- 生成买家支出记录
        INSERT INTO WalletRecords
            (UserID, TransactionID, Type, Amount, Balance, Timestamp)
        VALUES
            (NEW.BuyerID, NEW.TransactionID, 'expense', -NEW.Price, buyer_balance, NOW());
        
        -- 生成卖家收入记录
        INSERT INTO WalletRecords
            (UserID, TransactionID, Type, Amount, Balance, Timestamp)
        VALUES
            (NEW.SellerID, NEW.TransactionID, 'income', NEW.Price, seller_balance, NOW());
        
        -- 从购物车中移除已购买装备
        DELETE FROM Cart 
        WHERE UserID = NEW.BuyerID AND EquipmentID = NEW.EquipmentID;
        
        RETURN NEW;
    END;
    $$;


ALTER FUNCTION public.process_completed_transaction() OWNER TO postgres;

--
-- Name: remove_from_cart_on_inactive(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.remove_from_cart_on_inactive() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    BEGIN
        IF NEW.Status = 'inactive' AND OLD.Status = 'active' THEN
            DELETE FROM Cart WHERE EquipmentID = NEW.EquipmentID;
        END IF;
        RETURN NEW;
    END;
    $$;


ALTER FUNCTION public.remove_from_cart_on_inactive() OWNER TO postgres;

--
-- Name: withdraw_funds(integer, numeric); Type: PROCEDURE; Schema: public; Owner: postgres
--

CREATE PROCEDURE public.withdraw_funds(IN user_id integer, IN amount numeric, OUT success boolean, OUT message text)
    LANGUAGE plpgsql
    AS $$
    DECLARE
        current_balance NUMERIC(10,2);
        new_balance NUMERIC(10,2);
    BEGIN
        IF amount <= 0 THEN
            success := FALSE;
            message := '提现金额必须大于0';
            RETURN;
        END IF;
        
        -- 检查余额
        SELECT Balance INTO current_balance FROM Users WHERE UserID = user_id;
        
        IF current_balance < amount THEN
            success := FALSE;
            message := '余额不足，当前余额: ' || current_balance;
            RETURN;
        END IF;
        
        -- 扣减余额
        UPDATE Users 
        SET Balance = Balance - amount 
        WHERE UserID = user_id
        RETURNING Balance INTO new_balance;
        
        -- 创建流水记录
        INSERT INTO WalletRecords
            (UserID, Type, Amount, Balance, Timestamp)
        VALUES 
            (user_id, 'withdraw', -amount, new_balance, NOW());
        
        success := TRUE;
        message := '提现成功，当前余额: ' || new_balance;
    EXCEPTION
        WHEN OTHERS THEN
            success := FALSE;
            message := '提现失败: ' || SQLERRM;
    END;
    $$;


ALTER PROCEDURE public.withdraw_funds(IN user_id integer, IN amount numeric, OUT success boolean, OUT message text) OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: equipments; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.equipments (
    equipmentid integer NOT NULL,
    sellerid integer,
    equipmentname character varying(100) NOT NULL,
    category character varying(20),
    level integer,
    rarity character varying(20),
    attributes json,
    price numeric(10,2) NOT NULL,
    listeddate timestamp without time zone,
    status character varying(20),
    imageurl character varying(255)
);


ALTER TABLE public.equipments OWNER TO postgres;

--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users (
    userid integer NOT NULL,
    username character varying(50) NOT NULL,
    password character varying(64) NOT NULL,
    email character varying(100) NOT NULL,
    phone character varying(20),
    registrationdate timestamp without time zone,
    balance numeric(10,2) DEFAULT 0,
    creditrating integer,
    status character varying(20),
    role character varying(20) DEFAULT 'user'::character varying
);


ALTER TABLE public.users OWNER TO postgres;

--
-- Name: activeequipmentview; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.activeequipmentview AS
 SELECT e.equipmentid,
    e.equipmentname,
    e.category,
    e.level,
    e.rarity,
    e.price,
    e.listeddate,
    u.username AS sellername,
    u.userid AS sellerid
   FROM (public.equipments e
     JOIN public.users u ON ((e.sellerid = u.userid)))
  WHERE ((e.status)::text = 'active'::text);


ALTER VIEW public.activeequipmentview OWNER TO postgres;

--
-- Name: cart; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cart (
    cartid integer NOT NULL,
    userid integer,
    equipmentid integer,
    addeddate timestamp without time zone
);


ALTER TABLE public.cart OWNER TO postgres;

--
-- Name: cart_cartid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.cart_cartid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.cart_cartid_seq OWNER TO postgres;

--
-- Name: cart_cartid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.cart_cartid_seq OWNED BY public.cart.cartid;


--
-- Name: equipments_equipmentid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.equipments_equipmentid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.equipments_equipmentid_seq OWNER TO postgres;

--
-- Name: equipments_equipmentid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.equipments_equipmentid_seq OWNED BY public.equipments.equipmentid;


--
-- Name: pricechangemessages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pricechangemessages (
    messageid integer NOT NULL,
    userid integer,
    equipmentid integer,
    oldprice numeric(10,2),
    newprice numeric(10,2),
    changedate timestamp without time zone,
    isread boolean
);


ALTER TABLE public.pricechangemessages OWNER TO postgres;

--
-- Name: pricechangemessages_messageid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pricechangemessages_messageid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.pricechangemessages_messageid_seq OWNER TO postgres;

--
-- Name: pricechangemessages_messageid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pricechangemessages_messageid_seq OWNED BY public.pricechangemessages.messageid;


--
-- Name: transactions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.transactions (
    transactionid integer NOT NULL,
    equipmentid integer,
    sellerid integer,
    buyerid integer,
    transactiondate timestamp without time zone,
    price numeric(10,2),
    status character varying(30),
    paymentmethod character varying(20),
    completiondate timestamp without time zone
);


ALTER TABLE public.transactions OWNER TO postgres;

--
-- Name: transactions_transactionid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.transactions_transactionid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.transactions_transactionid_seq OWNER TO postgres;

--
-- Name: transactions_transactionid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.transactions_transactionid_seq OWNED BY public.transactions.transactionid;


--
-- Name: userequipmentview; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.userequipmentview AS
 SELECT e.equipmentid,
    e.equipmentname,
    e.category,
    e.level,
    e.rarity,
    e.price,
    e.listeddate,
    e.status,
    u.userid,
    u.username
   FROM (public.equipments e
     JOIN public.users u ON ((e.sellerid = u.userid)));


ALTER VIEW public.userequipmentview OWNER TO postgres;

--
-- Name: users_userid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.users_userid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.users_userid_seq OWNER TO postgres;

--
-- Name: users_userid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_userid_seq OWNED BY public.users.userid;


--
-- Name: usertransactionsview; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.usertransactionsview AS
 SELECT t.transactionid,
    t.transactiondate,
    t.price,
    e.equipmentid,
    e.equipmentname,
    e.category,
    s.username AS sellername,
    s.userid AS sellerid,
    b.username AS buyername,
    b.userid AS buyerid
   FROM (((public.transactions t
     JOIN public.equipments e ON ((t.equipmentid = e.equipmentid)))
     JOIN public.users s ON ((t.sellerid = s.userid)))
     JOIN public.users b ON ((t.buyerid = b.userid)));


ALTER VIEW public.usertransactionsview OWNER TO postgres;

--
-- Name: walletrecords; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.walletrecords (
    recordid integer NOT NULL,
    userid integer,
    transactionid integer,
    type character varying(20),
    amount numeric(10,2),
    balance numeric(10,2),
    "timestamp" timestamp without time zone
);


ALTER TABLE public.walletrecords OWNER TO postgres;

--
-- Name: userwalletsummary; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.userwalletsummary AS
 SELECT u.userid,
    u.username,
    u.balance,
    count(
        CASE
            WHEN ((w.type)::text = 'deposit'::text) THEN 1
            ELSE NULL::integer
        END) AS depositcount,
    count(
        CASE
            WHEN ((w.type)::text = 'withdraw'::text) THEN 1
            ELSE NULL::integer
        END) AS withdrawcount,
    count(
        CASE
            WHEN ((w.type)::text = ANY ((ARRAY['income'::character varying, 'expense'::character varying])::text[])) THEN 1
            ELSE NULL::integer
        END) AS transactioncount
   FROM (public.users u
     LEFT JOIN public.walletrecords w ON ((u.userid = w.userid)))
  GROUP BY u.userid, u.username, u.balance;


ALTER VIEW public.userwalletsummary OWNER TO postgres;

--
-- Name: walletrecords_recordid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.walletrecords_recordid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.walletrecords_recordid_seq OWNER TO postgres;

--
-- Name: walletrecords_recordid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.walletrecords_recordid_seq OWNED BY public.walletrecords.recordid;


--
-- Name: cart cartid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cart ALTER COLUMN cartid SET DEFAULT nextval('public.cart_cartid_seq'::regclass);


--
-- Name: equipments equipmentid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.equipments ALTER COLUMN equipmentid SET DEFAULT nextval('public.equipments_equipmentid_seq'::regclass);


--
-- Name: pricechangemessages messageid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricechangemessages ALTER COLUMN messageid SET DEFAULT nextval('public.pricechangemessages_messageid_seq'::regclass);


--
-- Name: transactions transactionid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions ALTER COLUMN transactionid SET DEFAULT nextval('public.transactions_transactionid_seq'::regclass);


--
-- Name: users userid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users ALTER COLUMN userid SET DEFAULT nextval('public.users_userid_seq'::regclass);


--
-- Name: walletrecords recordid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.walletrecords ALTER COLUMN recordid SET DEFAULT nextval('public.walletrecords_recordid_seq'::regclass);


--
-- Data for Name: cart; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.cart (cartid, userid, equipmentid, addeddate) FROM stdin;
888857	525099	248637	2025-01-02 03:57:52
685585	257419	196100	2025-05-09 06:19:00
797766	549948	196100	2025-01-22 04:40:05
112260	293205	839912	2025-05-06 07:00:08
644432	844842	664007	2025-05-11 08:44:17
185527	412752	856965	2025-01-07 20:30:18
488819	288698	787988	2025-03-09 10:21:39
835141	993840	790058	2025-04-04 05:40:57
531253	288698	828722	2025-04-02 06:17:50
859508	823001	345765	2025-02-25 09:19:54
967720	644947	582367	2025-01-09 06:55:41
655488	422042	979166	2025-04-19 06:21:57
875020	229013	232859	2025-02-11 05:20:55
889755	539640	337797	2025-04-08 12:32:52
273840	264173	659067	2025-01-07 21:03:04
953986	360449	589068	2025-02-18 17:44:00
725921	400937	690283	2025-01-10 05:07:50
144061	360449	492208	2025-03-26 10:13:23
270570	360058	200283	2025-01-06 13:27:36
196444	245078	232859	2025-05-03 14:38:05
506363	412752	945597	2025-04-30 01:41:17
450472	226702	839912	2025-01-24 21:26:16
442496	808973	284510	2025-02-12 08:35:12
165798	222339	452792	2025-04-06 01:30:15
740873	112335	992110	2025-03-27 18:07:59
885962	992746	741212	2025-01-13 15:33:01
644767	687331	492208	2025-04-19 01:08:18
269024	950785	430895	2025-02-20 11:07:25
527822	662976	358213	2025-04-08 04:50:28
362560	552426	682624	2025-03-08 13:28:25
594756	247964	728173	2025-03-21 02:57:14
740003	247964	712680	2025-05-15 12:29:37
480756	461630	828722	2025-04-14 20:02:18
238767	996682	248637	2025-02-15 09:20:30
742382	613627	721335	2025-01-04 05:08:31
855342	274103	659067	2025-05-16 06:33:31
258389	371225	713399	2025-02-06 05:57:50
518099	400937	917297	2025-02-02 04:43:23
459944	831240	808293	2025-04-02 18:44:12
218001	274171	600033	2025-03-01 10:21:45
920611	108176	200283	2025-01-27 01:39:13
840040	719460	741212	2025-05-12 22:39:06
247515	721470	984177	2025-05-16 20:42:43
734485	108176	764712	2025-05-17 01:36:30
410761	902260	877099	2025-01-10 13:26:06
114282	447041	117618	2025-04-21 13:50:40
666674	209609	828722	2025-01-21 05:37:41
477809	136119	714305	2025-04-18 21:54:50
609169	371225	868286	2025-05-01 11:56:41
722099	941224	203828	2025-04-07 06:39:13
271338	613627	856965	2025-05-03 09:04:38
715519	229013	708072	2025-04-18 00:21:00
763448	845804	768447	2025-04-19 09:15:10
311838	360449	293943	2025-03-20 01:43:19
847698	136119	430895	2025-02-09 06:50:48
173420	356043	452792	2025-02-10 16:02:56
850027	687331	917297	2025-04-06 18:40:33
403058	958551	345765	2025-05-19 22:45:46
764442	247964	854957	2025-03-28 12:38:05
132776	997430	489721	2025-01-20 23:04:07
787420	721470	790058	2025-04-10 21:53:40
265200	627679	633174	2025-01-04 20:33:05
123186	108176	160595	2025-04-09 23:40:07
728769	719460	877099	2025-03-31 17:15:40
408450	597311	977443	2025-03-02 00:00:58
109734	627679	790058	2025-03-29 09:38:15
909429	102627	581530	2025-02-23 20:58:57
376959	644947	659067	2025-04-26 15:20:49
898787	539916	492533	2025-02-20 04:54:53
991288	136119	492533	2025-02-23 12:41:24
399428	229013	890671	2025-04-16 00:35:34
540366	231433	654924	2025-05-18 13:40:57
499684	613627	992110	2025-03-14 10:34:03
537853	136119	282236	2025-03-21 08:59:47
516725	846269	395171	2025-05-17 17:07:42
835101	867277	945597	2025-04-02 19:49:17
406239	242505	705712	2025-02-14 22:47:44
309454	729678	856293	2025-02-25 02:35:52
294259	274103	196100	2025-04-25 06:18:44
131087	958551	921534	2025-04-12 21:25:10
656386	627679	996110	2025-04-02 08:52:02
321264	242505	395171	2025-03-13 12:49:16
595037	461630	713399	2025-01-22 02:49:51
482580	539640	227886	2025-04-01 01:20:36
896689	725863	144241	2025-04-07 16:49:13
825486	108176	200283	2025-01-17 04:32:35
406613	245078	786841	2025-02-06 02:36:27
831643	400937	262256	2025-05-04 21:36:13
245519	902260	712680	2025-01-20 14:28:35
842927	249496	621238	2025-02-21 12:21:20
367985	467086	878881	2025-01-06 03:29:42
516598	447041	298458	2025-02-21 22:19:05
455000	223343	577980	2025-01-25 07:16:21
234781	627679	728173	2025-02-12 00:52:47
742813	274171	912413	2025-02-12 21:07:16
581913	136119	430895	2025-05-12 04:27:35
519584	274171	877099	2025-05-18 19:23:07
253407	844842	787988	2025-05-01 07:46:29
163801	269928	643834	2025-01-26 13:43:47
156387	958551	581530	2025-02-05 09:45:14
100008	100001	100002	2025-05-21 20:49:55.160462
100012	100000	839912	2025-05-24 17:06:25.503578
100013	100000	659067	2025-05-24 17:06:27.964168
\.


--
-- Data for Name: equipments; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.equipments (equipmentid, sellerid, equipmentname, category, level, rarity, attributes, price, listeddate, status, imageurl) FROM stdin;
728173	274103	影响34	武器	89	rare	{"\\u653b\\u51fb": 96, "\\u9632\\u5fa1": 40}	286.97	2025-04-10 00:41:33	active	https://picsum.photos/619/480
271224	400937	品牌96	武器	59	common	{"\\u653b\\u51fb": 24, "\\u9632\\u5fa1": 7}	208.04	2025-04-24 03:30:13	removed	https://dummyimage.com/384x692
496979	867277	可是61	防具	48	legendary	{"\\u653b\\u51fb": 50, "\\u9632\\u5fa1": 47}	204.77	2025-02-09 07:49:40	sold	https://placekitten.com/410/743
984177	279126	精华19	材料	10	rare	{"\\u653b\\u51fb": 51, "\\u9632\\u5fa1": 27}	162.30	2025-01-19 19:50:24	removed	https://placekitten.com/936/280
993925	412752	一直90	饰品	4	epic	{"\\u653b\\u51fb": 56, "\\u9632\\u5fa1": 14}	41.16	2025-04-24 01:57:48	sold	https://picsum.photos/1021/974
917297	102627	法律73	武器	93	rare	{"\\u653b\\u51fb": 56, "\\u9632\\u5fa1": 41}	402.60	2025-02-06 18:11:16	sold	https://placekitten.com/700/11
337797	360449	有关18	防具	31	uncommon	{"\\u653b\\u51fb": 88, "\\u9632\\u5fa1": 27}	192.40	2025-03-22 18:30:04	active	https://dummyimage.com/927x378
296843	662976	报告89	饰品	73	epic	{"\\u653b\\u51fb": 83, "\\u9632\\u5fa1": 30}	417.56	2025-05-13 02:13:26	active	https://dummyimage.com/182x700
203828	662976	原因10	饰品	18	common	{"\\u653b\\u51fb": 36, "\\u9632\\u5fa1": 42}	14.51	2025-02-05 16:04:23	removed	https://placekitten.com/896/219
654924	884060	很多100	防具	68	epic	{"\\u653b\\u51fb": 64, "\\u9632\\u5fa1": 21}	308.24	2025-02-26 07:49:21	sold	https://placekitten.com/342/457
395171	740813	为什62	武器	81	common	{"\\u653b\\u51fb": 70, "\\u9632\\u5fa1": 18}	70.24	2025-05-05 21:10:36	active	https://placekitten.com/272/750
600033	902260	上海64	材料	7	legendary	{"\\u653b\\u51fb": 51, "\\u9632\\u5fa1": 33}	173.12	2025-05-15 07:54:49	removed	https://dummyimage.com/546x279
868286	102627	威望9	材料	38	epic	{"\\u653b\\u51fb": 67, "\\u9632\\u5fa1": 13}	201.05	2025-03-17 12:14:01	active	https://picsum.photos/523/333
952453	102627	东西29	武器	78	epic	{"\\u653b\\u51fb": 77, "\\u9632\\u5fa1": 30}	314.82	2025-01-29 12:10:36	removed	https://picsum.photos/545/760
839912	249496	注意81	材料	77	epic	{"\\u653b\\u51fb": 95, "\\u9632\\u5fa1": 33}	477.55	2025-03-19 22:34:42	active	https://picsum.photos/847/985
582367	662976	这种21	防具	7	legendary	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 19}	273.53	2025-01-04 15:59:02	active	https://picsum.photos/670/197
712680	222339	到了51	防具	19	common	{"\\u653b\\u51fb": 15, "\\u9632\\u5fa1": 22}	115.64	2025-04-07 01:45:09	active	https://placekitten.com/496/866
912413	245078	文章18	防具	9	uncommon	{"\\u653b\\u51fb": 74, "\\u9632\\u5fa1": 34}	34.40	2025-05-15 08:17:00	removed	https://dummyimage.com/762x493
358213	958551	全国90	饰品	44	legendary	{"\\u653b\\u51fb": 47, "\\u9632\\u5fa1": 26}	358.33	2025-04-29 06:36:43	removed	https://picsum.photos/994/331
293943	360449	重要95	材料	32	legendary	{"\\u653b\\u51fb": 92, "\\u9632\\u5fa1": 41}	353.43	2025-03-09 02:27:46	active	https://picsum.photos/832/883
282236	356043	信息77	武器	23	epic	{"\\u653b\\u51fb": 100, "\\u9632\\u5fa1": 11}	493.16	2025-04-13 02:59:33	sold	https://dummyimage.com/577x200
492533	725863	发生75	饰品	56	legendary	{"\\u653b\\u51fb": 22, "\\u9632\\u5fa1": 18}	244.53	2025-04-23 20:09:36	active	https://placekitten.com/651/545
659067	947467	希望65	防具	49	common	{"\\u653b\\u51fb": 92, "\\u9632\\u5fa1": 36}	122.17	2025-02-28 04:24:58	active	https://dummyimage.com/770x533
997709	400937	经济33	材料	77	epic	{"\\u653b\\u51fb": 65, "\\u9632\\u5fa1": 30}	55.81	2025-03-29 04:51:01	removed	https://placekitten.com/590/391
589068	371225	设备91	材料	46	epic	{"\\u653b\\u51fb": 71, "\\u9632\\u5fa1": 16}	113.28	2025-04-23 05:31:09	removed	https://dummyimage.com/290x222
633174	349402	深圳95	武器	9	rare	{"\\u653b\\u51fb": 24, "\\u9632\\u5fa1": 27}	457.56	2025-03-26 10:14:59	sold	https://placekitten.com/41/1010
705712	387042	地方54	防具	31	epic	{"\\u653b\\u51fb": 89, "\\u9632\\u5fa1": 32}	300.35	2025-02-21 04:29:07	active	https://picsum.photos/432/200
708876	831240	资源63	饰品	45	rare	{"\\u653b\\u51fb": 16, "\\u9632\\u5fa1": 11}	323.43	2025-02-04 07:01:58	removed	https://dummyimage.com/298x839
600674	222339	其中7	材料	86	rare	{"\\u653b\\u51fb": 86, "\\u9632\\u5fa1": 38}	87.33	2025-01-10 06:57:51	active	https://dummyimage.com/447x56
664007	289814	必须90	防具	38	legendary	{"\\u653b\\u51fb": 34, "\\u9632\\u5fa1": 43}	84.98	2025-01-23 11:46:25	sold	https://dummyimage.com/1000x930
996110	974064	简介27	武器	55	common	{"\\u653b\\u51fb": 39, "\\u9632\\u5fa1": 22}	139.93	2025-05-17 16:36:13	removed	https://dummyimage.com/174x264
878881	992746	日本98	防具	93	legendary	{"\\u653b\\u51fb": 68, "\\u9632\\u5fa1": 14}	162.85	2025-01-26 01:45:45	removed	https://placekitten.com/364/52
828722	823001	我们1	防具	32	epic	{"\\u653b\\u51fb": 36, "\\u9632\\u5fa1": 25}	402.55	2025-02-16 16:14:11	sold	https://placekitten.com/571/777
682624	269928	怎么90	武器	34	epic	{"\\u653b\\u51fb": 19, "\\u9632\\u5fa1": 43}	98.50	2025-02-21 16:10:38	sold	https://placekitten.com/226/577
439580	447041	社会50	武器	54	legendary	{"\\u653b\\u51fb": 30, "\\u9632\\u5fa1": 38}	48.87	2025-04-23 16:42:47	sold	https://dummyimage.com/694x87
452792	226702	不是15	材料	99	rare	{"\\u653b\\u51fb": 48, "\\u9632\\u5fa1": 23}	63.10	2025-01-18 09:52:58	removed	https://picsum.photos/136/721
260213	814318	最大70	防具	94	uncommon	{"\\u653b\\u51fb": 75, "\\u9632\\u5fa1": 40}	109.06	2025-02-03 01:24:01	removed	https://placekitten.com/577/402
621238	569529	如果83	防具	94	uncommon	{"\\u653b\\u51fb": 85, "\\u9632\\u5fa1": 25}	63.33	2025-02-25 19:50:00	removed	https://placekitten.com/918/450
284510	725863	关系89	饰品	52	epic	{"\\u653b\\u51fb": 97, "\\u9632\\u5fa1": 9}	90.41	2025-04-23 13:34:14	sold	https://picsum.photos/430/576
492208	276705	原因95	防具	49	legendary	{"\\u653b\\u51fb": 24, "\\u9632\\u5fa1": 50}	88.73	2025-03-29 01:45:33	active	https://placekitten.com/478/590
768447	804659	首页79	防具	48	uncommon	{"\\u653b\\u51fb": 44, "\\u9632\\u5fa1": 12}	272.54	2025-03-01 07:52:12	sold	https://picsum.photos/533/932
787988	257419	报告71	防具	29	legendary	{"\\u653b\\u51fb": 58, "\\u9632\\u5fa1": 50}	482.91	2025-03-31 14:49:45	active	https://placekitten.com/729/88
790058	349402	上海10	防具	62	epic	{"\\u653b\\u51fb": 58, "\\u9632\\u5fa1": 12}	446.66	2025-02-12 17:35:37	removed	https://placekitten.com/441/227
992110	222339	支持25	饰品	11	common	{"\\u653b\\u51fb": 47, "\\u9632\\u5fa1": 9}	163.35	2025-01-21 13:55:03	removed	https://dummyimage.com/558x66
932566	644947	大家33	材料	35	rare	{"\\u653b\\u51fb": 54, "\\u9632\\u5fa1": 12}	269.12	2025-01-23 11:55:57	sold	https://picsum.photos/320/649
893877	242505	男人48	防具	88	common	{"\\u653b\\u51fb": 20, "\\u9632\\u5fa1": 41}	401.78	2025-04-24 03:16:18	removed	https://picsum.photos/386/791
359094	613627	个人67	饰品	77	uncommon	{"\\u653b\\u51fb": 20, "\\u9632\\u5fa1": 17}	134.27	2025-04-22 09:32:19	removed	https://picsum.photos/33/947
227886	609684	商品27	材料	23	uncommon	{"\\u653b\\u51fb": 88, "\\u9632\\u5fa1": 40}	19.23	2025-04-19 15:06:55	sold	https://placekitten.com/803/495
764712	108176	今天76	防具	11	epic	{"\\u653b\\u51fb": 49, "\\u9632\\u5fa1": 21}	229.12	2025-03-16 19:53:05	removed	https://picsum.photos/432/236
856293	469660	最新1	饰品	58	common	{"\\u653b\\u51fb": 100, "\\u9632\\u5fa1": 28}	81.63	2025-04-07 12:44:31	removed	https://picsum.photos/515/678
248637	725863	一次23	武器	6	uncommon	{"\\u653b\\u51fb": 46, "\\u9632\\u5fa1": 16}	235.90	2025-04-13 12:22:39	removed	https://placekitten.com/65/157
741212	790598	系列24	防具	95	epic	{"\\u653b\\u51fb": 55, "\\u9632\\u5fa1": 22}	208.06	2025-02-06 04:12:30	sold	https://picsum.photos/654/878
890758	387042	经验59	防具	70	legendary	{"\\u653b\\u51fb": 72, "\\u9632\\u5fa1": 11}	183.90	2025-05-16 23:56:07	sold	https://placekitten.com/974/230
890671	902260	推荐17	武器	77	common	{"\\u653b\\u51fb": 36, "\\u9632\\u5fa1": 49}	326.84	2025-02-03 23:09:02	sold	https://placekitten.com/403/735
577980	874824	这样2	武器	37	legendary	{"\\u653b\\u51fb": 90, "\\u9632\\u5fa1": 28}	85.64	2025-03-16 18:33:44	removed	https://placekitten.com/166/759
207602	360449	完成66	防具	55	legendary	{"\\u653b\\u51fb": 98, "\\u9632\\u5fa1": 12}	255.40	2025-02-11 18:42:34	sold	https://placekitten.com/129/357
345765	371336	时候1	饰品	49	common	{"\\u653b\\u51fb": 19, "\\u9632\\u5fa1": 47}	309.25	2025-04-07 22:06:24	sold	https://picsum.photos/142/441
977443	229013	重要44	材料	70	legendary	{"\\u653b\\u51fb": 84, "\\u9632\\u5fa1": 36}	385.43	2025-05-06 07:26:09	removed	https://picsum.photos/173/862
945597	242505	安全82	饰品	31	common	{"\\u653b\\u51fb": 80, "\\u9632\\u5fa1": 16}	378.94	2025-01-28 11:14:17	removed	https://placekitten.com/959/896
160595	422042	商品49	武器	45	uncommon	{"\\u653b\\u51fb": 99, "\\u9632\\u5fa1": 36}	431.94	2025-03-28 06:04:24	active	https://picsum.photos/379/736
430895	447041	主要56	材料	34	rare	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 6}	181.17	2025-04-22 07:44:03	removed	https://picsum.photos/666/240
771778	627679	这是53	防具	94	common	{"\\u653b\\u51fb": 59, "\\u9632\\u5fa1": 15}	434.16	2025-02-10 07:01:44	sold	https://dummyimage.com/753x184
877099	539916	游戏51	武器	43	legendary	{"\\u653b\\u51fb": 95, "\\u9632\\u5fa1": 18}	403.55	2025-04-22 05:46:01	sold	https://picsum.photos/248/290
847060	687331	支持61	武器	94	uncommon	{"\\u653b\\u51fb": 20, "\\u9632\\u5fa1": 16}	199.19	2025-02-13 01:02:11	removed	https://placekitten.com/750/118
298458	740813	市场52	武器	26	rare	{"\\u653b\\u51fb": 52, "\\u9632\\u5fa1": 36}	113.06	2025-02-14 22:50:15	sold	https://picsum.photos/450/114
103090	285940	市场59	材料	45	uncommon	{"\\u653b\\u51fb": 100, "\\u9632\\u5fa1": 12}	139.63	2025-02-24 02:58:55	active	https://placekitten.com/34/938
941479	127520	不同31	材料	61	rare	{"\\u653b\\u51fb": 56, "\\u9632\\u5fa1": 31}	127.66	2025-01-21 13:46:52	sold	https://dummyimage.com/921x752
934838	627679	简介59	饰品	63	rare	{"\\u653b\\u51fb": 65, "\\u9632\\u5fa1": 16}	464.02	2025-01-01 07:06:59	active	https://dummyimage.com/615x537
876641	269928	也是88	防具	4	legendary	{"\\u653b\\u51fb": 58, "\\u9632\\u5fa1": 41}	279.42	2025-04-13 23:44:12	sold	https://dummyimage.com/271x279
643834	539916	一次95	饰品	67	legendary	{"\\u653b\\u51fb": 19, "\\u9632\\u5fa1": 22}	173.69	2025-04-19 16:20:43	active	https://placekitten.com/33/826
117618	281050	电脑75	防具	74	common	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 18}	264.79	2025-03-28 18:19:00	sold	https://picsum.photos/260/823
713399	360058	完全68	武器	34	uncommon	{"\\u653b\\u51fb": 60, "\\u9632\\u5fa1": 25}	167.31	2025-03-13 20:55:56	sold	https://placekitten.com/271/990
742399	293205	音乐71	防具	26	epic	{"\\u653b\\u51fb": 26, "\\u9632\\u5fa1": 37}	296.42	2025-05-02 23:48:17	sold	https://dummyimage.com/617x45
856965	269928	个人44	饰品	18	uncommon	{"\\u653b\\u51fb": 15, "\\u9632\\u5fa1": 26}	429.17	2025-02-15 11:35:40	sold	https://dummyimage.com/720x940
816470	249496	语言2	武器	42	rare	{"\\u653b\\u51fb": 83, "\\u9632\\u5fa1": 37}	169.05	2025-01-13 21:57:54	sold	https://dummyimage.com/669x398
262256	729678	法律99	武器	12	common	{"\\u653b\\u51fb": 42, "\\u9632\\u5fa1": 29}	410.25	2025-01-14 16:25:01	sold	https://picsum.photos/692/730
438066	965382	有限14	武器	55	rare	{"\\u653b\\u51fb": 44, "\\u9632\\u5fa1": 45}	361.47	2025-04-03 14:03:53	removed	https://picsum.photos/690/670
851441	360449	大家7	饰品	37	common	{"\\u653b\\u51fb": 83, "\\u9632\\u5fa1": 9}	265.78	2025-01-19 19:32:06	sold	https://placekitten.com/798/688
704354	209609	记者12	武器	8	uncommon	{"\\u653b\\u51fb": 96, "\\u9632\\u5fa1": 16}	240.06	2025-03-26 19:44:50	sold	https://picsum.photos/80/450
700790	958551	介绍52	材料	22	rare	{"\\u653b\\u51fb": 86, "\\u9632\\u5fa1": 37}	216.78	2025-04-01 17:26:19	sold	https://picsum.photos/176/142
107051	371336	地址19	饰品	49	uncommon	{"\\u653b\\u51fb": 25, "\\u9632\\u5fa1": 20}	100.08	2025-04-26 22:14:52	sold	https://dummyimage.com/995x1005
979166	597311	行业32	饰品	17	uncommon	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 14}	92.74	2025-02-06 05:49:39	sold	https://placekitten.com/205/439
196100	467086	是否69	武器	95	uncommon	{"\\u653b\\u51fb": 70, "\\u9632\\u5fa1": 36}	176.23	2025-05-10 16:15:50	removed	https://picsum.photos/9/993
581530	247964	来源42	饰品	63	common	{"\\u653b\\u51fb": 13, "\\u9632\\u5fa1": 21}	216.53	2025-02-13 19:41:47	removed	https://placekitten.com/1007/627
855605	349402	时候24	防具	40	epic	{"\\u653b\\u51fb": 62, "\\u9632\\u5fa1": 17}	13.22	2025-02-13 07:57:07	active	https://picsum.photos/591/880
921534	274103	空间47	防具	65	rare	{"\\u653b\\u51fb": 21, "\\u9632\\u5fa1": 36}	341.91	2025-05-09 23:34:25	removed	https://dummyimage.com/724x586
413660	288698	当前95	武器	71	rare	{"\\u653b\\u51fb": 100, "\\u9632\\u5fa1": 26}	499.11	2025-02-11 01:04:30	sold	https://placekitten.com/193/461
721335	801904	经验62	饰品	96	legendary	{"\\u653b\\u51fb": 45, "\\u9632\\u5fa1": 37}	311.30	2025-04-09 02:00:15	active	https://dummyimage.com/671x457
714305	276705	时候97	饰品	38	common	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 48}	312.54	2025-02-03 16:41:58	removed	https://picsum.photos/402/148
808293	467086	只要35	武器	100	uncommon	{"\\u653b\\u51fb": 19, "\\u9632\\u5fa1": 8}	401.16	2025-03-30 06:29:16	sold	https://dummyimage.com/164x436
441713	231433	自己92	武器	98	uncommon	{"\\u653b\\u51fb": 74, "\\u9632\\u5fa1": 25}	70.71	2025-02-25 11:09:14	sold	https://dummyimage.com/747x4
489721	884060	广告78	防具	15	uncommon	{"\\u653b\\u51fb": 74, "\\u9632\\u5fa1": 8}	119.74	2025-03-14 16:28:19	sold	https://dummyimage.com/196x984
708072	108176	当前81	材料	2	uncommon	{"\\u653b\\u51fb": 11, "\\u9632\\u5fa1": 12}	445.76	2025-03-01 18:44:15	sold	https://placekitten.com/342/84
232859	289814	报告39	防具	32	common	{"\\u653b\\u51fb": 13, "\\u9632\\u5fa1": 47}	53.00	2025-04-28 13:36:36	sold	https://placekitten.com/923/929
200283	613627	法律42	材料	48	epic	{"\\u653b\\u51fb": 90, "\\u9632\\u5fa1": 45}	408.68	2025-04-12 08:55:16	sold	https://dummyimage.com/126x264
690283	569529	同时27	饰品	35	legendary	{"\\u653b\\u51fb": 72, "\\u9632\\u5fa1": 43}	367.83	2025-05-07 15:59:26	sold	https://placekitten.com/776/280
925867	269928	一样24	防具	13	common	{"\\u653b\\u51fb": 74, "\\u9632\\u5fa1": 25}	363.74	2025-04-28 17:27:57	sold	https://dummyimage.com/160x7
144241	790297	加入70	武器	83	common	{"\\u653b\\u51fb": 77, "\\u9632\\u5fa1": 35}	284.24	2025-05-19 22:11:48	sold	https://picsum.photos/879/170
786841	461630	只要95	饰品	72	rare	{"\\u653b\\u51fb": 68, "\\u9632\\u5fa1": 42}	346.10	2025-02-25 08:22:58	sold	https://picsum.photos/959/479
854957	569529	数据7	防具	60	legendary	{"\\u653b\\u51fb": 96, "\\u9632\\u5fa1": 12}	220.62	2025-04-17 06:42:12	sold	https://picsum.photos/925/513
100003	100001	绝妙珠	材料	1	common	\N	1.00	2025-05-21 20:46:30.209723	active	\N
100004	100001	大王花	材料	1	common	\N	20.00	2025-05-21 20:46:48.096204	active	\N
100005	100001	吸铁石	材料	1	common	\N	1.00	2025-05-21 20:47:07.89018	active	\N
100002	100000	石中剑	武器	50	rare	{"\\u653b\\u51fb": 10, "\\u9632\\u5fa1": 55}	800.00	2025-05-21 20:34:07.999019	active	None
100001	100000	千年裹尸布	饰品	99	legendary	{"\\u653b\\u51fb": 500, "\\u9632\\u5fa1": 666}	80.00	2025-05-21 20:06:13.125136	active	None
100006	100000	魔法精灵球	武器	50	legendary	{"\\u653b\\u51fb": 600, "\\u9632\\u5fa1": 5}	9.90	2025-05-24 14:14:07.576651	sold	None
100007	100000	破晓	武器	1	legendary	{"\\u653b\\u51fb": 60, "\\u9632\\u5fa1": 0}	2500.00	2025-05-24 14:48:18.0649	active	\N
100000	100000	不是今天	防具	1	common	{"\\u653b\\u51fb": 0, "\\u9632\\u5fa1": 999}	999.00	2025-05-21 20:04:58.683936	active	\N
100008	100001	破晓	武器	20	legendary	{"\\u653b\\u51fb": 60, "\\u9632\\u5fa1": 0}	89.00	2025-05-24 14:49:17.63641	sold	\N
\.


--
-- Data for Name: pricechangemessages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.pricechangemessages (messageid, userid, equipmentid, oldprice, newprice, changedate, isread) FROM stdin;
785210	808973	786841	494.83	422.31	2025-01-16 20:40:05	t
693418	965382	925867	293.00	107.87	2025-05-01 12:40:35	t
109525	823001	851441	410.18	84.80	2025-02-15 15:56:27	t
442991	108176	284510	104.08	90.32	2025-01-06 06:28:31	t
384704	412752	917297	298.67	346.18	2025-05-20 03:31:21	t
112675	844842	993925	231.76	469.15	2025-04-05 12:03:22	t
933302	360449	643834	208.16	179.30	2025-02-19 16:41:42	t
122181	845804	298458	62.58	244.05	2025-02-16 04:39:20	f
207811	950785	232859	352.73	122.57	2025-01-07 08:15:24	t
558410	360449	430895	466.41	268.09	2025-03-29 15:41:50	t
242379	592710	808293	428.07	411.16	2025-01-05 03:40:41	f
439175	539916	979166	73.68	481.94	2025-02-24 17:33:11	t
620318	719460	984177	477.15	186.95	2025-05-17 07:41:16	t
351632	200188	441713	493.15	91.12	2025-01-07 13:34:18	t
927241	447041	582367	189.39	481.82	2025-05-18 04:51:24	f
683151	569529	659067	431.36	478.13	2025-04-04 13:53:21	t
819171	808973	232859	332.56	93.46	2025-04-21 20:50:52	f
776469	209609	117618	129.26	285.50	2025-03-17 04:58:04	t
269389	289814	582367	449.61	430.15	2025-01-31 03:23:21	f
243932	801904	207602	342.77	240.28	2025-04-03 09:52:43	t
114523	200188	768447	413.76	380.98	2025-04-10 19:23:06	t
871251	627679	600033	482.70	497.11	2025-02-09 21:43:17	t
282841	980494	489721	76.99	97.80	2025-03-19 15:33:34	f
391587	274103	786841	103.99	80.26	2025-03-14 19:37:02	t
137010	269928	993925	326.08	391.42	2025-02-04 12:27:54	t
817599	863019	854957	211.54	384.06	2025-04-22 09:19:09	t
900163	422042	577980	250.17	169.16	2025-02-16 22:46:49	f
248155	525099	452792	124.26	48.58	2025-01-16 19:03:49	f
392486	349402	713399	234.03	50.24	2025-04-14 00:33:30	f
181064	226702	643834	497.88	352.29	2025-03-18 22:48:13	t
407234	461630	856293	204.25	490.02	2025-03-06 05:34:15	f
454974	136119	103090	168.33	285.84	2025-02-07 02:22:27	t
430271	274171	600033	94.06	227.97	2025-05-02 04:15:49	f
865455	304578	996110	270.50	337.21	2025-04-03 01:08:41	t
760089	739843	704354	266.19	146.74	2025-01-17 10:48:51	f
215809	288698	439580	432.61	438.35	2025-05-03 23:11:21	t
289825	644947	816470	353.08	214.72	2025-01-06 04:34:17	f
839196	469660	345765	145.85	304.44	2025-03-17 20:50:09	f
137317	569529	207602	74.21	448.86	2025-03-05 12:41:07	f
756276	461630	232859	76.16	131.71	2025-04-08 17:03:47	f
506022	539916	496979	233.25	184.74	2025-01-23 16:34:31	f
333371	569529	704354	204.84	296.59	2025-04-03 14:05:22	t
894760	993840	282236	253.40	392.21	2025-05-05 11:39:58	f
332919	200188	808293	325.81	447.31	2025-01-10 18:58:44	f
290615	947467	893877	384.21	290.29	2025-03-23 08:27:47	f
427195	245078	117618	80.57	471.05	2025-01-06 01:23:25	t
808025	941224	117618	227.75	276.23	2025-03-03 06:34:40	f
846125	349402	890671	188.12	224.05	2025-03-18 07:18:40	f
345632	231433	232859	149.88	127.01	2025-05-19 12:35:35	f
193204	530323	984177	85.39	191.06	2025-04-13 19:25:01	f
432915	387042	742399	29.50	139.24	2025-05-15 14:15:01	f
433235	687331	996110	327.42	400.72	2025-04-16 17:59:09	f
752993	721470	103090	134.52	69.68	2025-02-12 10:20:26	f
883543	209609	992110	132.39	439.91	2025-02-16 09:09:42	f
952438	247964	977443	162.13	214.17	2025-04-12 07:10:46	f
371130	136119	260213	48.12	278.50	2025-03-07 21:14:05	t
820675	245078	452792	299.87	109.57	2025-03-03 13:56:31	f
172011	285940	262256	121.42	223.19	2025-03-15 08:13:12	f
402511	356043	890671	214.24	159.33	2025-03-15 16:21:55	f
625853	823001	876641	452.46	98.01	2025-05-09 23:48:14	f
195401	274103	847060	228.09	81.88	2025-02-05 17:05:50	t
357350	958551	452792	169.53	259.95	2025-01-01 17:55:40	f
649824	846269	395171	361.47	271.49	2025-02-16 02:12:17	f
336712	592710	103090	330.06	345.49	2025-03-29 15:26:29	f
456588	245078	851441	464.98	132.86	2025-02-16 14:45:41	t
357753	371336	787988	304.66	214.10	2025-04-11 09:04:30	t
339721	552426	581530	267.27	22.39	2025-03-17 02:49:06	f
868150	222339	600674	201.18	402.88	2025-02-10 19:51:49	t
874633	549948	984177	379.67	176.21	2025-01-10 10:00:30	t
829086	288698	203828	256.78	238.85	2025-01-31 13:55:07	f
164866	242505	786841	303.10	436.95	2025-03-05 14:59:26	f
268468	867277	600033	375.17	399.92	2025-01-01 01:38:12	f
624562	226702	932566	217.69	302.54	2025-04-04 05:40:47	t
879621	461630	876641	457.54	105.08	2025-05-10 17:23:55	t
110663	127520	808293	121.86	170.69	2025-01-26 18:31:42	t
822814	223343	708876	119.58	427.53	2025-02-03 18:59:05	f
729205	867277	262256	469.03	414.21	2025-02-26 23:06:45	t
987152	371225	856293	37.39	181.42	2025-05-04 14:28:23	f
562685	831240	600674	475.24	242.74	2025-01-11 01:58:31	f
941608	264173	705712	271.13	16.41	2025-03-05 01:18:43	f
972931	844842	200283	453.99	329.02	2025-04-02 06:55:05	t
421151	941224	117618	338.71	51.90	2025-05-03 03:39:05	t
422839	831240	828722	14.28	65.01	2025-02-10 10:28:33	t
302857	229013	708876	450.38	56.00	2025-03-21 07:36:30	f
665337	293205	704354	448.24	420.90	2025-01-10 12:23:54	t
325609	525099	359094	205.13	175.47	2025-02-20 15:46:12	f
652087	863019	856965	294.25	209.05	2025-03-24 11:04:10	f
648603	947467	682624	421.41	382.38	2025-03-29 03:31:15	f
696181	993840	345765	461.00	168.35	2025-02-25 15:16:54	t
459857	200188	893877	467.06	247.91	2025-03-30 00:54:10	t
348730	349402	582367	333.37	44.04	2025-04-20 00:25:31	f
913178	644947	713399	166.12	107.92	2025-04-21 21:09:50	t
904779	613627	855605	153.73	273.85	2025-01-13 18:43:39	t
771138	993840	232859	221.91	485.99	2025-04-23 09:06:00	f
595382	725863	984177	477.03	172.83	2025-02-07 16:24:35	f
795308	281050	977443	180.28	483.70	2025-04-07 21:18:01	f
689816	552426	714305	308.42	222.20	2025-02-14 08:24:51	t
213824	422042	600674	83.95	57.38	2025-01-29 02:14:51	f
710124	814318	492533	274.68	401.69	2025-01-16 02:23:42	f
482209	229013	643834	346.59	337.96	2025-01-14 07:16:16	f
100001	100001	100002	90.00	800.00	2025-05-21 20:50:07.692907	t
100000	100001	100001	9999.00	80.00	2025-05-21 20:48:08.136126	t
100002	100001	100006	99.00	9.90	2025-05-24 14:41:17.84363	t
\.


--
-- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transactions (transactionid, equipmentid, sellerid, buyerid, transactiondate, price, status, paymentmethod, completiondate) FROM stdin;
732628	705712	387042	609684	2025-05-09 19:39:25	300.35	cancelled	银行卡	2025-01-01 09:50:21
618259	997709	400937	687331	2025-02-23 19:03:39	55.81	pending_payment	支付宝	2025-04-13 22:29:18
507466	877099	539916	884060	2025-03-10 21:11:38	403.55	completed	银行卡	2025-03-10 06:05:55
166608	977443	229013	107970	2025-05-05 22:46:50	385.43	pending_payment	微信	2025-04-25 18:19:19
210724	847060	687331	387042	2025-03-17 12:45:59	199.19	pending_payment	支付宝	2025-05-20 09:27:34
694106	979166	597311	790598	2025-01-06 06:43:14	92.74	refunded	微信	2025-05-04 04:53:19
638963	786841	461630	965382	2025-03-17 09:18:28	346.10	pending_payment	微信	2025-01-10 09:07:17
878129	877099	539916	627679	2025-02-08 09:42:54	403.55	completed	微信	2025-01-27 01:43:09
820889	917297	102627	980494	2025-02-23 17:23:13	402.60	refunded	微信	2025-03-31 07:39:28
543299	728173	274103	525099	2025-04-24 19:48:56	286.97	refunded	银行卡	2025-04-12 14:21:39
606340	107051	371336	447041	2025-02-28 02:47:28	100.08	cancelled	银行卡	2025-04-12 11:48:13
437536	984177	279126	721470	2025-02-21 12:02:08	162.30	pending_payment	银行卡	2025-02-17 20:51:22
443235	200283	613627	740813	2025-03-14 09:19:36	408.68	refunded	银行卡	2025-01-31 02:43:40
116178	839912	249496	360449	2025-02-16 20:00:55	477.55	pending_payment	微信	2025-05-13 22:46:32
217288	107051	371336	790297	2025-02-22 12:20:15	100.08	cancelled	银行卡	2025-03-14 00:40:10
306536	787988	257419	349402	2025-04-30 12:01:56	482.91	completed	银行卡	2025-02-02 00:51:35
681109	786841	461630	223343	2025-04-12 00:21:49	346.10	completed	支付宝	2025-02-24 05:41:37
308074	682624	269928	844842	2025-01-29 17:08:54	98.50	completed	支付宝	2025-04-12 08:45:09
841868	345765	371336	947467	2025-01-14 18:14:29	309.25	completed	支付宝	2025-03-21 11:59:08
680520	144241	790297	371336	2025-05-06 22:50:36	284.24	completed	支付宝	2025-01-06 23:10:48
213260	856965	269928	289814	2025-04-07 11:39:14	429.17	refunded	支付宝	2025-04-04 00:30:59
149263	271224	400937	371336	2025-02-02 07:20:57	208.04	pending_payment	支付宝	2025-03-29 07:12:11
963772	868286	102627	539640	2025-01-11 14:00:21	201.05	completed	银行卡	2025-04-15 23:36:56
830055	992110	222339	549948	2025-01-14 02:13:44	163.35	cancelled	支付宝	2025-01-24 11:07:51
280463	260213	814318	226702	2025-01-16 17:38:34	109.06	refunded	支付宝	2025-04-12 17:18:06
811922	452792	226702	662976	2025-04-22 06:51:17	63.10	pending_payment	支付宝	2025-05-20 04:43:26
453209	856293	469660	200188	2025-01-13 12:14:17	81.63	pending_payment	银行卡	2025-03-23 19:06:11
466439	839912	249496	360058	2025-04-25 15:32:04	477.55	completed	微信	2025-01-22 16:39:35
883625	690283	569529	687331	2025-02-08 07:58:05	367.83	refunded	支付宝	2025-03-20 07:48:21
942621	992110	222339	467086	2025-05-07 00:52:16	163.35	cancelled	支付宝	2025-05-17 12:30:37
553040	358213	958551	549948	2025-03-14 23:39:50	358.33	completed	微信	2025-01-21 06:50:04
879238	856293	469660	371225	2025-01-27 07:57:59	81.63	completed	支付宝	2025-01-02 02:50:52
230874	839912	249496	845804	2025-03-09 21:39:20	477.55	completed	微信	2025-01-11 04:47:39
802275	839912	249496	530323	2025-01-25 22:25:52	477.55	cancelled	银行卡	2025-03-19 02:03:29
628103	992110	222339	371225	2025-02-18 04:44:24	163.35	cancelled	微信	2025-05-11 02:42:47
142073	690283	569529	721470	2025-03-25 09:25:57	367.83	pending_payment	支付宝	2025-03-14 06:32:41
480193	934838	627679	884060	2025-04-25 13:53:05	464.02	completed	支付宝	2025-04-18 11:47:39
449770	932566	644947	249496	2025-02-01 19:57:25	269.12	completed	微信	2025-03-27 20:57:56
335888	496979	867277	245078	2025-01-07 04:04:25	204.77	cancelled	微信	2025-03-21 01:07:53
552898	996110	974064	412752	2025-02-28 06:03:31	139.93	completed	微信	2025-01-16 14:07:01
158891	284510	725863	102627	2025-03-23 09:03:51	90.41	cancelled	支付宝	2025-03-11 08:46:55
103590	764712	108176	136119	2025-01-05 14:43:45	229.12	pending_payment	微信	2025-03-31 02:05:13
555879	260213	814318	400937	2025-01-28 01:55:03	109.06	completed	银行卡	2025-01-29 08:05:21
115970	997709	400937	360058	2025-02-19 04:54:22	55.81	refunded	微信	2025-02-12 01:35:58
154998	359094	613627	245078	2025-02-28 09:42:20	134.27	pending_payment	支付宝	2025-04-11 07:26:13
204411	107051	371336	245078	2025-01-15 05:03:34	100.08	completed	微信	2025-05-18 15:22:33
380071	921534	274103	108176	2025-02-01 16:08:20	341.91	completed	微信	2025-05-03 14:41:34
770151	496979	867277	592710	2025-03-15 15:28:45	204.77	cancelled	支付宝	2025-04-23 20:40:26
878549	714305	276705	229013	2025-04-13 02:26:02	312.54	pending_payment	微信	2025-03-02 00:02:46
666147	260213	814318	627679	2025-05-16 01:11:23	109.06	cancelled	微信	2025-01-01 05:50:53
448364	196100	467086	469660	2025-05-04 02:52:34	176.23	completed	银行卡	2025-03-04 08:58:38
734418	847060	687331	644947	2025-02-01 21:08:57	199.19	refunded	支付宝	2025-04-25 02:42:50
508384	728173	274103	751045	2025-02-19 17:58:20	286.97	refunded	微信	2025-04-30 15:29:42
332584	103090	285940	844842	2025-03-30 02:39:48	139.63	cancelled	银行卡	2025-01-30 12:35:19
503871	271224	400937	453468	2025-02-15 14:50:27	208.04	refunded	微信	2025-05-10 21:53:09
628174	160595	422042	247964	2025-01-27 04:53:43	431.94	completed	支付宝	2025-04-17 17:30:58
958426	227886	609684	725863	2025-02-17 07:49:23	19.23	cancelled	银行卡	2025-03-09 16:56:42
928739	855605	349402	107970	2025-01-07 00:27:48	13.22	pending_payment	银行卡	2025-03-31 16:53:06
786614	790058	349402	831240	2025-04-30 19:04:01	446.66	pending_payment	支付宝	2025-03-01 07:00:21
833944	260213	814318	739843	2025-04-24 17:36:24	109.06	completed	微信	2025-03-09 00:28:31
410073	952453	102627	539640	2025-03-19 01:38:50	314.82	pending_payment	微信	2025-03-03 14:37:20
790771	430895	447041	223343	2025-05-20 04:00:37	181.17	completed	支付宝	2025-03-31 22:53:35
449745	921534	274103	285940	2025-04-26 20:58:43	341.91	completed	微信	2025-04-27 16:18:45
409339	839912	249496	831240	2025-03-02 07:10:25	477.55	cancelled	支付宝	2025-01-30 07:39:43
679043	893877	242505	107970	2025-01-16 15:02:40	401.78	refunded	微信	2025-02-12 23:23:14
650367	439580	447041	687331	2025-04-27 23:17:15	48.87	pending_payment	微信	2025-02-26 14:22:53
907346	868286	102627	597311	2025-03-10 14:10:47	201.05	refunded	支付宝	2025-03-08 03:32:39
656193	868286	102627	289814	2025-04-15 09:00:45	201.05	refunded	微信	2025-01-23 15:13:46
747636	284510	725863	902260	2025-05-08 23:19:52	90.41	completed	微信	2025-02-11 18:21:32
565819	103090	285940	950785	2025-05-12 16:37:18	139.63	pending_payment	支付宝	2025-04-18 04:01:55
932174	117618	281050	823001	2025-03-05 02:32:17	264.79	cancelled	微信	2025-04-17 08:29:37
880330	260213	814318	304578	2025-04-03 01:31:38	109.06	pending_payment	微信	2025-04-06 15:46:42
388636	787988	257419	200188	2025-01-26 12:04:40	482.91	pending_payment	支付宝	2025-03-10 23:01:26
544632	200283	613627	863019	2025-02-21 23:26:44	408.68	pending_payment	支付宝	2025-03-15 17:47:26
986321	877099	539916	958551	2025-03-19 07:14:05	403.55	cancelled	银行卡	2025-03-18 11:40:02
677247	704354	209609	453468	2025-02-18 12:02:55	240.06	completed	支付宝	2025-04-29 16:01:59
551395	577980	874824	844842	2025-02-15 04:24:41	85.64	cancelled	银行卡	2025-03-23 04:52:51
978348	581530	247964	729678	2025-01-25 12:23:34	216.53	refunded	银行卡	2025-03-31 02:22:19
895715	741212	790598	790297	2025-03-28 23:01:14	208.06	pending_payment	微信	2025-05-12 08:50:35
444970	439580	447041	569529	2025-05-02 23:15:49	48.87	completed	银行卡	2025-01-07 15:44:57
217390	705712	387042	609684	2025-05-14 06:01:21	300.35	completed	银行卡	2025-02-10 10:59:57
369181	708072	108176	539640	2025-03-18 22:22:43	445.76	completed	微信	2025-01-09 17:05:36
371364	984177	279126	662976	2025-04-10 07:08:37	162.30	cancelled	支付宝	2025-01-29 16:18:49
128731	103090	285940	447041	2025-01-21 09:20:51	139.63	pending_payment	微信	2025-02-07 01:51:10
697836	713399	360058	846269	2025-01-03 06:14:16	167.31	cancelled	银行卡	2025-02-15 21:09:11
382626	144241	790297	609684	2025-04-30 02:05:26	284.24	completed	微信	2025-01-29 05:56:30
562687	728173	274103	790297	2025-02-14 00:48:53	286.97	completed	微信	2025-01-08 07:14:26
399276	912413	245078	751045	2025-05-08 06:44:43	34.40	refunded	支付宝	2025-02-17 02:13:05
388702	200283	613627	774719	2025-02-22 17:22:39	408.68	pending_payment	银行卡	2025-02-07 14:53:10
872369	847060	687331	285940	2025-01-09 03:22:48	199.19	cancelled	支付宝	2025-01-09 01:12:25
583808	997709	400937	293205	2025-03-08 12:03:39	55.81	pending_payment	支付宝	2025-03-16 21:38:51
921319	589068	371225	400937	2025-05-13 22:54:19	113.28	cancelled	支付宝	2025-01-11 17:48:09
221599	293943	360449	739843	2025-04-30 12:31:09	353.43	pending_payment	支付宝	2025-05-14 09:36:07
299092	855605	349402	662976	2025-03-15 14:24:38	13.22	completed	支付宝	2025-05-02 04:18:56
156977	359094	613627	947467	2025-05-10 14:25:37	134.27	refunded	银行卡	2025-03-10 17:21:45
472011	496979	867277	549948	2025-05-09 15:47:15	204.77	pending_payment	支付宝	2025-03-13 18:39:02
791623	207602	360449	993840	2025-03-21 04:54:30	255.40	pending_payment	微信	2025-05-04 01:55:13
664710	787988	257419	947467	2025-03-31 13:47:41	482.91	pending_payment	支付宝	2025-01-09 06:38:00
570671	271224	400937	371225	2025-01-04 19:53:12	208.04	completed	微信	2025-01-17 01:31:24
482035	144241	790297	201099	2025-02-06 22:59:44	284.24	completed	银行卡	2025-02-04 11:45:08
100000	925867	269928	100000	2025-05-21 11:19:33.621176	363.74	completed	\N	\N
100001	144241	790297	100000	2025-05-21 11:19:33.621176	284.24	completed	\N	\N
100002	786841	461630	100000	2025-05-21 16:43:53.5697	346.10	completed	\N	\N
100003	708072	108176	100000	2025-05-21 16:43:53.5697	445.76	completed	\N	\N
100004	232859	289814	100000	2025-05-21 19:29:00.936652	53.00	completed	\N	\N
100005	854957	569529	100000	2025-05-21 20:08:13.622353	220.62	completed	\N	\N
100006	200283	613627	100000	2025-05-21 20:16:22.306426	408.68	completed	\N	\N
100007	100006	100000	100001	2025-05-24 14:42:13.536048	9.90	completed	\N	\N
100013	100008	100001	100000	2025-05-24 17:10:24.104987	89.00	completed	\N	\N
100014	227886	609684	100000	2025-05-24 17:10:55.469972	19.23	completed	\N	\N
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (userid, username, password, email, phone, registrationdate, balance, creditrating, status, role) FROM stdin;
980494	wei87	23f3f79116b40ac4d9470afe215879c5e3d0f636e35124519b2e4d2d4fa3e776	shenna@example.org	15285236398	2025-01-24 08:27:57	33.46	2	unverified	admin
257419	pxiong	5206f323065f90e5f23db6c72834ad61a73ce7f1ef60fe8855bf0ae8521b9d1d	jing65@example.org	13893962950	2022-07-24 06:03:55	194.04	5	banned	user
102627	fengping	9ab42eadf62283f6047fe3258e79e666701a6dac5252436e484edcc6072e2b84	fxiang@example.org	13818112896	2021-01-06 12:39:07	975.32	2	active	user
245078	xia99	aba9838757e91099853be1666aa48a6b51e429c3499d12084e00cb6f383717b5	otang@example.org	13063769652	2020-01-17 19:15:20	395.40	2	banned	user
127520	xia84	84543516617aa5d7422cf19a9f0dc67ade3ab6949943c0318c4a3c79cf96f599	sbai@example.org	13733959326	2023-04-21 07:26:22	444.03	2	unverified	user
797824	jie77	3dda3941c33fa2f3f6ceab618f09900135014b7948a801470a1b100ad180e4fd	kzheng@example.net	13734679714	2024-03-18 06:19:42	561.17	1	banned	user
107970	yongli	61581edeca5379a1a4be9890d5f57af0fada48887b24d18d1b344b66244b86d6	gang62@example.org	14595770873	2024-12-20 04:54:53	35.62	3	active	user
808973	oluo	23a62125eb8314a52b800f534d9248b8ac4ef91c5d10ce00784743a5b855aa1b	weijie@example.com	18235760232	2024-10-30 17:14:39	505.34	1	active	user
279126	bzhou	27c1624cd1ac41f50baa742ecb5c952e8fa2ed006bc36f845d395b4df08167fd	nzou@example.com	18700058401	2022-01-25 12:58:57	287.65	5	active	user
226702	kyu	b9eeaa8962bec8acd0b6523a0968bc140541451ce301b016d423ae12bc32204f	yan38@example.org	13939496374	2020-12-10 20:45:12	130.84	4	banned	user
597311	weiliang	bae4bf0160b3a36792a1e78c834aa05c737aa0b05065b706a4c554507f030ba6	chengyan@example.com	15122148318	2020-04-28 05:05:35	400.90	1	banned	user
729678	chaogong	187ef0e6db2c791bd258110c067f59af304171c45ce760e3c845c1c6d618b9e4	li44@example.com	18218018084	2020-07-15 00:59:19	619.83	5	active	user
774719	yanxiuying	ff7b393907734a0e31e97aeab6a24ecaf743e21e783da784f2aa4cac0a771332	na19@example.com	15703600964	2023-05-26 22:16:14	606.25	5	banned	user
814318	panfang	889aecedef41749212a726e860192cc0a212f6ff1963ac74e0f42bfd4135c705	dengmin@example.net	14730086700	2021-01-30 17:53:10	974.79	3	unverified	user
627679	yanwu	b88df29a9bfaf7fa15eccfa90a4169aede4b3fe567bfa1ba95a3fc5d3fdeddc6	juan64@example.com	15976549455	2025-04-17 08:54:32	638.82	1	active	user
469660	fengjie	c811e9fa1c0628571a32ea91d95165e80ae0cc571a05a739abcdc0926f98a07f	jingdeng@example.net	18869299840	2024-04-09 15:17:53	238.26	5	unverified	user
447041	yanjia	b9cd30171f3c2d0e0529f09fde36c04501e3406a78622cec065d07b1a4e803d6	dingmin@example.net	18129352002	2024-09-07 03:54:09	923.25	2	unverified	user
400937	yefang	a68aab9a1ee11808c59332537d04c7895eca8b705214a0616da1165f86dacd65	tao65@example.com	15291860290	2021-04-23 20:26:23	905.97	4	unverified	user
846269	donggang	9ac1bd751e047a5934eec6a020333e4db6464a5eaa12d5fd9def7fc6f138cfb4	guiying88@example.com	13892871140	2022-07-02 18:12:09	593.13	2	banned	user
958551	dugang	7ec06bf3e69162a1404b3d9e8bdbe714bf4317c5dd7b85dcfe44ef345423a6d7	dutao@example.net	18012363990	2024-07-01 00:56:50	53.92	1	unverified	user
281050	pingtan	2603d450132402ec9ed1579bab34618a2b4aeb68538691319c035e7bf69b213e	btian@example.org	13162221852	2022-01-21 19:56:34	717.31	1	active	user
360449	dbai	f3dc149e5e2029dea08a942734f61aad2df266cce1c18328c8e1b73459bbf72d	taoxu@example.org	18979020309	2022-05-06 03:29:28	168.40	5	active	user
242505	juan14	5488d5bd47b95034340d74ef1eee164ffe46428aa1124a1ec0455e2e43922d25	xiulanqiao@example.net	18594665110	2023-03-31 02:10:14	793.40	3	unverified	user
136119	jing63	ec2e5cb5a6b91c904c764ec5387c5374f0417e45d0789b19dc73247854234be7	li77@example.net	13544822475	2025-02-05 06:26:16	104.92	2	active	user
941224	nshao	6b3a41a7771e5f52735a309554385c60d4cadf255789477f66ed0a70d1ed36cc	ming52@example.org	15798489372	2020-06-14 10:54:08	438.30	3	active	user
274171	xiongping	28537d8f74219e2290f5cca434507a23fcb44e852c34d7927e244aa5086f3ced	qiang73@example.com	13778902123	2023-01-14 16:15:29	343.26	2	banned	user
549948	yong44	faf86c0d668a6cce110c6e388d623d74cc27371d8f2645f08310ffb48e3f785a	tzeng@example.com	14721700414	2023-02-14 23:31:35	807.25	1	unverified	user
293205	yangyang	13ad911e860c0fbfafe2e2ad334e7be99cc2a46bdf871be76fe5894c7249858e	jingzhong@example.com	15514731391	2021-06-16 06:38:04	228.36	2	active	user
802039	tshen	2a5daf8ee4c847f42206a6b9f359b5c13853dbd308b5288a725a82a99f6b4c92	nxue@example.org	15716272410	2021-05-16 08:15:55	570.12	3	banned	user
112335	yan04	d4a5862581cbff762517b9820dcb56d02bb00a787ae596275853dce89a711593	yongyin@example.net	18159509649	2022-06-19 20:13:22	578.00	3	unverified	user
687331	gang81	2e69bf9c8a0f5dcf4d9a4ef7c1934bdf80e8bd9de8da9b99dd85d25bddeab7e6	juan65@example.org	18700263196	2025-02-16 11:53:43	775.79	2	active	user
867277	na32	1f5ab37efb124e992002cdc7cc49498b87448a3689637a87eeec77a938503378	naxie@example.org	15783032343	2025-02-24 11:59:13	250.88	2	unverified	user
247964	junxu	7b724d3911fe2662f013cea6cde04a00aa51aec5faf43f2fabfb8cc072328977	yang21@example.com	15108161826	2020-04-22 08:36:00	966.39	3	active	user
965382	longjuan	4bb027c762697ec908349c847286b76ded4499e0f6c558bdade9aeaaec7a0d0e	juan03@example.net	13063893170	2023-06-17 18:45:37	212.55	3	unverified	user
592710	taoqiu	d0d8730a898cfb6e2fa68c8e87d39aaa745a90a87cd7ba3ec7e45bf66f0d89b8	guqiang@example.org	13191643160	2021-09-24 18:09:56	782.50	2	banned	user
863019	iyang	2f3076b24c1371583caa0250584eb8c8b44706c44cf7ce8499d3859bd93a6055	wei50@example.com	13230908724	2020-05-04 14:33:16	131.31	5	unverified	user
739843	sujie	072adb38ff4bdf10847d99c57b38e7903288ee63e063fc0b9ddbd145e06ccecb	wjin@example.com	18050869137	2024-11-17 09:42:44	661.76	3	active	user
274103	xiulancui	9841b4157467a7ce04d5441267992efd4a241197226731ff1139e0adf7d879b2	chao84@example.com	13287258049	2025-05-02 14:52:03	949.45	5	unverified	user
539640	sujing	bc6d4c4847336ec92e0ee925b4c9e062f350aa4586236d860d5ad32aa89974e2	ogao@example.net	14507858344	2022-10-21 05:56:29	170.27	2	banned	user
751045	ncao	b7421bcc5b29b7d9ec449a58dcc5b913391584dc1a56af889cf978a690fe0c93	wanming@example.com	15144095977	2022-08-27 10:25:55	883.64	3	banned	user
371225	tianyan	077a2072a4472836f012cd20e645b5b5717f235b5a47a6a5fd76ae3391e6e295	juan58@example.com	15343812180	2023-06-20 01:32:07	211.22	5	unverified	user
223343	jialei	3375b66f4870755cc8ffc65f8bc58f776827525d1d3978f9e2be34950409e7dc	pingzeng@example.org	18766788908	2023-06-13 23:24:31	18.06	2	banned	user
725863	omo	9b68e3fda7a26d6256dc2e5dcb6b4ec5d5c97a5ef4eb2c956c90d3264d6923bd	uhu@example.com	15042000817	2021-08-11 15:14:40	478.65	3	active	user
644947	jun71	dc9407ced8b568e6584fab8507326ec63982ea5ccfbe2b940d5f03271ed28d95	nachen@example.com	15025195730	2024-07-13 03:48:12	790.66	3	unverified	user
525099	zdeng	4cbddcabb98e9df143d3a2f91348209ef6a3a055f49f1e21d490ed42e99fca18	zhouyang@example.com	13244644022	2021-08-24 03:10:47	40.48	2	unverified	user
289814	yangzhao	5ce86a955d65b669bb11490627f47e7a23804aa6f906766f3517a62b30bbeae8	liangchao@example.com	15235107142	2022-02-26 19:00:53	271.37	1	banned	user
371336	xiulandai	cd75a6d3c62859d52130987b14a391a64d90a8bc1b1b7f494d2f9381149a3703	suqiang@example.org	18004297327	2023-07-18 11:59:34	360.16	5	banned	user
974064	pengxiulan	2f1deddacf5c7616850818ff6feb569be9634de0cee795a89aa984ebfa1d426c	wei40@example.com	15907474716	2022-01-10 11:03:36	98.31	4	banned	user
992746	jun60	137612d3496e935cf431d23400b1e7191310b146817e84dcaf415cd00d1e9e48	jiemo@example.com	18196966431	2023-03-05 13:33:26	225.91	2	unverified	user
823001	zhengfang	cf019c47b038547315779a9ceb756b5e6d59f43b84ac7222c4b77ac7c966133b	xuejing@example.org	13896856700	2022-10-25 01:42:53	516.37	1	unverified	user
552426	cuiyan	60afc6d5b0953bb9f5068c785723e00f399e44a38c574a5cb3282e7ebf16d99a	juan65@example.net	14527536746	2023-08-13 17:37:21	448.37	4	unverified	user
662976	weixu	b0d911826811f13fce8a86434f4a3bb69c834ce70054f627bb3e94109fc88c6b	fkong@example.org	18056833497	2023-12-30 22:29:49	157.80	3	unverified	user
950785	xiuying55	1cd0764911727262555dbd05381a0e9f0c2a38d396b4ce0bdbf56540158bdd4d	plin@example.com	14559821414	2020-09-06 09:39:30	637.97	4	banned	user
845804	liduan	a18e08c17906af7e59d6cd0d62de04203c37fdf451eb8e621f9c484f38c259e4	xiaqiu@example.net	15934808421	2023-02-06 01:31:30	385.47	3	unverified	user
360058	guiying87	3bb4bca7161ce27084ce04fa66836f943424f3b52f02241f73b1426c9dbcfc5d	jingmao@example.com	13538660605	2020-05-10 21:26:02	466.00	1	active	user
276705	xiuyingguo	07611d14adafe15dcfb87e32a710a264e04641879f47264cb4e5229638ecb88e	xiulantao@example.com	18185375109	2025-01-28 13:44:44	93.51	3	active	user
356043	guiying69	4c1af10c24a90bb688769ba1257430577b374aebcc7047677d39f22111acd1fc	wei75@example.com	13112359886	2021-08-29 00:02:03	414.14	5	unverified	user
387042	wangtao	ef443827c0f1baa1666ac847dd2c664a405fad9a07f82d8881182b638a1d123b	xiaoqiang@example.net	15331530381	2020-02-26 18:59:47	67.29	1	unverified	user
790598	zhangjing	e7233de58fa837688afda51342dc384cb21cff57857ea42e7a4b4f45dff9f3a5	yanyuan@example.com	15292560152	2022-03-23 14:25:44	366.89	2	banned	user
801904	yangqiao	e220000d5ef2760c0d5c79eaa00a30213dfb4c7ac5ba5393ddedaa49f6b31f8e	yanyin@example.org	13101235232	2020-07-06 11:01:42	526.74	2	unverified	user
229013	liaojie	90a44f6952c1fbe73c299b458a7d51c1f3c2f98b3146f78f616d55009db8af9f	min68@example.org	18834976576	2023-09-04 04:18:26	678.60	1	banned	user
467086	chenwei	acf4353cd3c4b00c86f4cbc20e5ea22b387d2289e28e779520a4458c9c796d4b	min99@example.com	15309743250	2024-01-07 09:21:03	24.62	5	active	user
304578	cdai	0a6a5f2e4301f64ce13f20225b9189542be39b541b27f6ec682e36470f7979d7	idai@example.org	15527396778	2020-04-06 02:52:40	425.91	4	active	user
249496	haojie	a0f1782bf212a81ec9e0c531d35f89376e6f3074f4ffa48fa261f999734a0b32	xiuying85@example.com	13270029696	2023-06-29 11:49:51	442.74	2	banned	user
231433	jiemao	2beaa225ce3f2df46bdc14a11fefd7bcccff4e27ae699b9752dd0e004ef31b1f	qiang27@example.org	14531566954	2024-03-06 04:25:00	61.00	4	unverified	user
884060	jun51	2a691e6af1dd1a929e77124b3841b0074087ba336a1d45ce58a6aa47d34fc67c	yzou@example.com	13500994045	2023-11-27 21:07:26	652.85	1	banned	user
874824	fding	dce04251d0f1ab4158fa55e7f69e44be3ee1a59a6265811ff0c9dd29209df5f3	bxiong@example.net	13673117784	2024-03-06 22:11:33	226.36	4	unverified	user
721470	chaoyi	9448e9b08ce75c7e4605bdec67aebbd03811476f4b9839544bc148de75082828	taotian@example.com	18816940834	2024-03-11 20:04:11	43.17	4	banned	user
831240	kxia	2120cac707e679e4f7f6719fb5f8ca19529ba81ad4ac581a0a0174dca943813d	yongtan@example.org	18672638703	2024-10-05 01:18:36	444.96	4	banned	user
530323	min88	90222714e524fc4bc3129a37adcaa9e9a7c27d27cda29f9256b75c73f605e07b	lixiao@example.org	18956896456	2023-07-25 19:38:38	479.71	4	banned	user
902260	yanming	225d5e2ef43055ae13ad5282cb06ee6468179317eb8e215f96f5a45c16b694a8	xiulanshao@example.com	13579876838	2023-06-20 12:06:34	270.20	5	banned	user
285940	kangguiying	880d4e6944756e7c4d77c57a848f748c2de129994f15b550fab104f92ece8a92	xwan@example.com	15277360062	2020-03-24 12:43:08	535.15	3	banned	user
900932	xia04	d717352d264d5343668731380c5c06c4d6b27bf24e36983f2adaf34e5c1eb9a9	taoyang@example.org	18111696100	2022-10-18 14:35:22	852.97	2	active	user
719460	alu	8e3a9a0e592b448919b3fd7563f6cb2b15c67ba5379855718c9fca8a4c2ca287	ryan@example.org	15672377390	2021-05-12 14:33:49	741.53	4	banned	user
288698	yan81	9963e58330081d269a76c2dd46795ea26fb454f5972970e75d4e0fbe0768c9b8	min30@example.org	13603154717	2022-02-07 20:06:11	128.67	1	unverified	user
539916	jun94	43ad7ff89e54f3a17ef317f935e638c70dc6fee09d53f39c09a36a634ca70f64	pxiang@example.com	13511570388	2022-12-07 14:27:27	274.30	5	banned	user
349402	junhuang	26f9f228844a85407e0af58921aa8fbcd790e538a86557c458585e156b2bd065	dxue@example.net	18048151230	2023-12-02 14:25:36	141.05	2	unverified	user
209609	zhuang	20aa02c88ea371e370a151e1602407fae0d922fbd5be321fd02b8047c94981a9	ilei@example.net	18778017051	2021-01-18 23:22:26	742.38	1	active	user
996682	pingjin	cdc35354ca9dd248f31bc3a92d70de093020f86114e74555740d1694f4f557dc	gdeng@example.com	15211146997	2022-04-16 17:57:06	380.89	5	active	user
412752	heyang	18ae2daf1d0d01f2f0d4726d3ac2faffa969d44f1583a621ad07dbe9f4e790fe	fangxie@example.com	13092867010	2023-09-01 22:06:39	367.52	2	unverified	user
740813	nading	4dc78de15bdfd2c8578389b5a164fbd03e5961425869c23262d14bd5e641155c	xiulantan@example.com	13932374492	2022-08-03 03:40:48	389.23	5	unverified	user
134796	sunjun	1d66f2a7364cc8b897f5a0a35353d2c8870e0615abff83980f08ac6e6f36b583	guiyingjiang@example.org	15784897807	2024-05-20 00:25:55	993.68	2	unverified	user
947467	flei	7069c6b12e091bb5f871b25dec427b8dab76a589b71e789ffe54edcdedc1a4a7	yong24@example.org	13248280473	2020-11-27 00:58:53	849.90	2	active	user
422042	minjia	e3cfc004619bf5da0377ffee7d70a65780af36dbbbcee5bafd15e546c1846d5c	xuexia@example.net	15114181470	2025-03-03 12:33:51	43.22	5	unverified	user
201099	yanqian	054b456d78ec523713ee14e8469bacd2aeebc19ce6c0732f0a1d973b516f5caf	wei30@example.net	18001087985	2022-12-22 12:13:51	838.32	3	unverified	user
804659	scheng	411ba7ba25f5d8ee2d418781c39f0c13073cded384952d83341024c05329f300	tangyan@example.org	18708688416	2022-04-15 13:48:38	957.74	3	active	user
222339	fang51	7fbc5a50e46f9c725df318889291675df45cb039071e99376345142b1b422be3	na06@example.com	15138691114	2025-01-19 14:40:07	50.01	4	active	user
569529	luojie	8ad4147a91ead0540790dce083ef1ec2d471a31de111a7295f95b6d0697768ee	qiangduan@example.org	18839566620	2024-12-17 20:37:32	1189.66	1	active	user
613627	tao04	1031308f17b045abab4669c21cefc36b448ae0191449726fbed0c9de3b325b7f	guiyingtang@example.com	13414526896	2024-12-08 17:43:27	962.38	2	banned	user
609684	xiayang	614e026bf1cd32033e27d33f77faa5363e7f454940a6b8ff5f49e9528c905bfc	ligao@example.org	13940180754	2023-05-26 21:35:57	315.04	2	active	user
453468	guomin	8cd621fbdda2430c0cea8f5f00b037a63a538bbdbb8611654535d86cdf8d79d1	sunna@example.net	18205916875	2022-07-10 18:36:08	148.23	1	active	user
997430	xia29	fee1e034a09218e71856ce3135933cc314fb7e1d98989b78c5abefcdf1c1c836	zhangyong@example.org	15228563483	2022-06-11 16:22:30	861.87	1	unverified	user
264173	dshen	d27ea7f0779359e5c69fe4235a08db95afa48b445b423e44ecc16c94162f772d	pingding@example.net	15214966171	2022-09-27 01:12:24	434.35	4	active	user
993840	renjuan	3dda5f9fc521a7b7ce28aeba38098efcc3e58e28cc4c8ad9f4c2add099dc5942	pingchen@example.org	15790432570	2022-05-16 05:27:25	257.05	1	active	user
200188	nkang	553080d4fe35ad7fc75b67bcd73406244dfae216100482c11a2faed336fa168f	pcui@example.com	18291287520	2023-10-27 07:12:22	232.66	4	banned	user
844842	gang70	a3c705abc37407d054bd64d59b86da677a933d2faf0020d92d0ab5cd73bf73a9	fanglu@example.net	15532273212	2020-10-22 23:05:20	897.62	4	banned	user
269928	mawei	db0cf96b5b62bbe9ea7a9b8622ecd5decbc49a3a573e6bb4617537d436aaec7e	izeng@example.org	15514915334	2023-12-08 23:28:15	951.19	1	unverified	user
790297	kongtao	804d813270cf1d2355c1a885c7605d1992a52535f01fec3a160955c499e66941	jiexia@example.org	15906146735	2020-04-25 09:24:01	744.51	3	banned	user
461630	ekang	16d7d6f3f68e021b9f12f5ca94405ec80693a234e16b7e8aca127c1c8c855071	wdai@example.net	13519389796	2025-04-03 00:31:58	352.62	3	banned	user
108176	taojie	99ed8a54ca000e11820128dcad17590a3c674fe34db967631e4c2778bf77a794	leiqiao@example.com	15210136475	2022-02-14 13:52:38	897.27	2	banned	user
100001	2955912927	145114	2955912927@qq.com	\N	2025-05-21 20:45:56.240366	100078.10	\N	\N	user
100000	20231003512	114514	20231003512@cug.edu.cn	\N	2025-05-21 10:00:23.959642	590.53	\N	\N	user
\.


--
-- Data for Name: walletrecords; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.walletrecords (recordid, userid, transactionid, type, amount, balance, "timestamp") FROM stdin;
809854	201099	565819	withdraw	114.84	1942.29	2025-05-15 04:31:21
912761	980494	472011	withdraw	126.72	1961.40	2025-05-12 06:36:42
828033	356043	449770	deposit	337.41	206.73	2025-02-16 04:34:02
246013	274171	448364	income	154.61	1477.24	2025-05-15 22:16:54
848826	127520	833944	withdraw	123.92	583.43	2025-05-17 17:16:44
875166	264173	932174	income	459.70	1110.15	2025-05-13 15:36:01
938947	974064	694106	expense	45.83	1582.93	2025-03-16 23:08:43
502007	790297	482035	deposit	77.45	504.45	2025-04-16 19:11:00
592028	814318	978348	withdraw	37.05	1531.92	2025-04-17 19:44:30
979618	201099	963772	income	129.07	1749.44	2025-03-05 19:06:39
741335	808973	697836	deposit	10.67	1578.45	2025-03-13 00:00:08
654108	874824	666147	income	94.77	550.49	2025-04-18 20:23:14
951117	400937	628103	expense	133.17	827.24	2025-04-09 17:50:43
538826	257419	638963	deposit	102.23	1179.77	2025-02-03 04:48:36
576760	360058	444970	withdraw	180.90	1107.98	2025-04-14 04:04:52
668724	264173	154998	deposit	45.22	800.26	2025-03-01 10:33:40
964538	360449	786614	deposit	110.20	1789.29	2025-02-18 18:56:59
507746	597311	790771	deposit	279.62	1940.93	2025-02-10 21:19:02
165960	997430	694106	expense	389.19	1831.14	2025-05-03 15:29:08
176358	293205	570671	deposit	493.00	1382.72	2025-03-03 17:58:27
124266	530323	830055	withdraw	84.86	1546.12	2025-03-06 02:11:18
188974	947467	932174	expense	273.92	1183.14	2025-02-27 07:32:00
125185	974064	299092	withdraw	183.85	943.64	2025-02-24 17:24:15
858920	751045	482035	expense	134.75	667.31	2025-03-25 17:37:35
127084	245078	166608	income	147.47	1382.01	2025-02-22 23:44:41
680354	245078	217390	withdraw	403.22	1821.38	2025-01-07 22:51:54
756216	721470	694106	deposit	299.80	723.66	2025-05-08 04:04:28
299114	530323	453209	deposit	180.17	1819.75	2025-04-29 03:55:54
728710	996682	811922	expense	457.21	892.41	2025-05-03 22:33:43
678390	293205	466439	expense	295.39	480.14	2025-01-14 18:09:17
827040	127520	878549	withdraw	18.08	990.03	2025-02-02 00:08:12
749486	102627	833944	deposit	364.57	1137.97	2025-05-04 11:50:53
529311	412752	790771	expense	143.13	1686.10	2025-01-23 13:06:47
496834	209609	449770	deposit	320.63	1235.36	2025-02-05 10:58:12
639916	257419	221599	deposit	483.32	11.30	2025-04-23 18:44:36
826383	453468	666147	income	301.14	230.75	2025-03-04 11:28:17
462858	552426	958426	expense	146.47	183.74	2025-03-23 08:41:21
250373	974064	879238	deposit	411.34	1488.30	2025-02-16 01:59:38
610543	274171	230874	expense	118.82	1293.76	2025-04-17 12:00:48
840739	222339	154998	expense	165.51	1534.83	2025-04-06 15:37:50
650625	808973	388636	income	420.18	819.43	2025-05-19 02:37:28
533497	980494	656193	expense	465.74	1187.72	2025-02-11 19:31:11
157924	525099	508384	deposit	246.81	1279.20	2025-01-04 12:33:04
437643	613627	553040	income	234.68	1287.60	2025-01-13 12:26:51
129742	257419	618259	withdraw	286.34	505.02	2025-04-23 21:10:15
580657	371225	606340	expense	91.25	431.06	2025-04-07 02:33:45
484308	797824	734418	income	43.19	867.54	2025-03-31 21:33:06
529353	525099	606340	income	392.18	1789.16	2025-02-13 17:29:19
592202	360058	380071	deposit	261.52	637.53	2025-02-12 21:37:23
777839	467086	437536	expense	366.56	634.69	2025-05-15 22:32:56
366455	461630	552898	deposit	71.64	1525.38	2025-04-13 04:24:08
657971	249496	544632	expense	60.86	748.43	2025-01-09 02:56:30
930981	997430	443235	withdraw	218.20	662.16	2025-01-08 14:14:44
889874	229013	958426	deposit	141.63	720.59	2025-01-19 10:14:04
698683	996682	878549	income	309.06	1951.56	2025-05-17 08:31:10
781489	801904	878129	deposit	85.09	105.19	2025-04-29 06:22:42
294075	739843	128731	deposit	343.10	834.26	2025-04-07 13:04:12
984395	107970	115970	withdraw	80.75	1828.32	2025-03-09 11:36:42
920146	867277	883625	income	387.23	1702.42	2025-04-21 17:33:26
587256	549948	958426	expense	469.38	1933.43	2025-03-07 20:36:40
267563	269928	677247	deposit	268.83	946.31	2025-02-18 04:47:59
817838	387042	551395	expense	40.08	556.89	2025-04-23 00:18:43
205690	209609	482035	income	432.39	1012.47	2025-05-17 14:41:02
624439	453468	482035	deposit	375.28	37.37	2025-05-15 12:38:41
524535	229013	128731	deposit	470.57	1713.20	2025-01-08 08:29:05
192999	993840	747636	deposit	421.45	594.28	2025-04-30 22:40:55
633321	867277	820889	income	93.59	1248.42	2025-04-30 20:24:27
821216	996682	606340	income	250.05	1256.94	2025-03-03 14:50:59
983728	863019	895715	deposit	46.28	582.81	2025-03-06 21:01:10
408733	467086	786614	withdraw	491.95	165.63	2025-01-31 00:54:33
711694	974064	371364	withdraw	379.65	55.31	2025-01-11 23:41:07
631304	549948	166608	deposit	149.85	1793.18	2025-04-14 14:39:04
293232	247964	508384	expense	450.23	1222.69	2025-01-11 09:49:05
338779	997430	380071	withdraw	314.17	883.11	2025-04-30 00:44:22
676517	740813	555879	deposit	244.97	1476.07	2025-03-22 01:37:09
582078	884060	650367	withdraw	139.29	1373.29	2025-04-27 12:02:09
143565	422042	679043	withdraw	418.32	1265.03	2025-05-20 10:07:26
138774	288698	221599	income	153.92	521.56	2025-05-18 10:03:38
584658	134796	299092	expense	159.80	1295.97	2025-03-07 08:09:56
164640	867277	570671	deposit	491.46	1494.77	2025-01-26 19:47:20
629910	276705	681109	income	162.67	1781.72	2025-03-26 00:09:54
756007	597311	583808	expense	177.79	1924.48	2025-02-02 09:21:56
181550	201099	942621	deposit	91.64	1499.82	2025-05-17 08:43:12
963374	257419	369181	expense	470.92	1409.34	2025-02-28 11:51:56
512657	980494	158891	deposit	53.67	1816.87	2025-01-03 20:48:33
950466	802039	449745	deposit	84.61	1860.56	2025-03-24 18:30:38
743262	467086	618259	deposit	476.05	850.75	2025-01-19 04:10:00
391141	980494	382626	expense	13.78	714.04	2025-02-13 05:09:18
895018	412752	628174	withdraw	371.41	777.01	2025-01-28 08:51:03
199739	592710	791623	withdraw	11.69	1916.86	2025-01-28 23:06:28
326586	360449	409339	expense	173.79	486.35	2025-03-24 05:19:20
675262	293205	942621	expense	406.56	1560.02	2025-01-04 06:06:39
639613	719460	382626	expense	74.91	370.45	2025-03-11 13:31:31
601499	200188	299092	deposit	299.76	1932.92	2025-01-22 17:46:54
364690	627679	880330	expense	208.37	1534.44	2025-04-08 18:23:19
872261	356043	802275	income	290.39	1588.28	2025-03-25 06:09:32
749818	549948	217390	deposit	120.10	1608.16	2025-02-23 06:20:20
920730	107970	570671	income	152.94	1749.59	2025-01-02 05:33:55
103691	980494	472011	expense	411.85	1691.38	2025-05-14 04:46:59
399257	950785	553040	expense	15.68	999.20	2025-03-26 14:54:30
100000	100000	\N	充值	1000.00	\N	2025-05-21 10:00:32.772386
100001	100000	\N	充值	156.00	\N	2025-05-21 10:00:51.552862
100002	100000	\N	提现	-485.00	\N	2025-05-21 10:01:03.743282
100003	100000	100000	expense	-363.74	307.26	2025-05-21 11:19:33.621176
100004	269928	100000	income	363.74	951.19	2025-05-21 11:19:33.621176
100005	100000	100001	expense	-284.24	23.02	2025-05-21 11:19:33.621176
100006	790297	100001	income	284.24	744.51	2025-05-21 11:19:33.621176
100007	100000	\N	充值	1000000.00	\N	2025-05-21 11:20:09.351086
100008	100000	\N	deposit	145.00	1000168.02	2025-05-21 11:26:09.953149
100009	100000	100002	expense	-346.10	999821.92	2025-05-21 16:43:53.5697
100010	461630	100002	income	346.10	352.62	2025-05-21 16:43:53.5697
100011	100000	100003	expense	-445.76	999376.16	2025-05-21 16:43:53.5697
100012	108176	100003	income	445.76	897.27	2025-05-21 16:43:53.5697
100013	100000	100004	expense	-53.00	999323.16	2025-05-21 19:29:00.936652
100014	289814	100004	income	53.00	271.37	2025-05-21 19:29:00.936652
100015	100000	\N	withdraw	-999000.00	323.16	2025-05-21 19:29:27.207053
100016	100000	\N	deposit	99999.00	100322.16	2025-05-21 19:29:35.190341
100017	100000	100005	expense	-220.62	100101.54	2025-05-21 20:08:13.622353
100018	569529	100005	income	220.62	1189.66	2025-05-21 20:08:13.622353
100019	100000	100006	expense	-408.68	99692.86	2025-05-21 20:16:22.306426
100020	613627	100006	income	408.68	962.38	2025-05-21 20:16:22.306426
100021	100001	\N	deposit	99999.00	99999.00	2025-05-24 14:41:52.742046
100022	100001	100007	expense	-9.90	99989.10	2025-05-24 14:42:13.536048
100023	100000	100007	income	9.90	99702.76	2025-05-24 14:42:13.536048
100024	100000	\N	deposit	986.00	100688.76	2025-05-24 17:05:10.558056
100035	100000	100013	expense	-89.00	100599.76	2025-05-24 17:10:24.104987
100036	100001	100013	income	89.00	100078.10	2025-05-24 17:10:24.104987
100037	100000	100014	expense	-19.23	100580.53	2025-05-24 17:10:55.469972
100038	609684	100014	income	19.23	315.04	2025-05-24 17:10:55.469972
100039	100000	\N	deposit	10.00	100590.53	2025-05-24 17:16:37.827118
100040	100000	\N	withdraw	-100000.00	590.53	2025-05-24 17:16:46.030759
\.


--
-- Name: cart_cartid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.cart_cartid_seq', 100014, true);


--
-- Name: equipments_equipmentid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.equipments_equipmentid_seq', 100008, true);


--
-- Name: pricechangemessages_messageid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.pricechangemessages_messageid_seq', 100002, true);


--
-- Name: transactions_transactionid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.transactions_transactionid_seq', 100014, true);


--
-- Name: users_userid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_userid_seq', 100001, true);


--
-- Name: walletrecords_recordid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.walletrecords_recordid_seq', 100040, true);


--
-- Name: cart cart_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cart
    ADD CONSTRAINT cart_pkey PRIMARY KEY (cartid);


--
-- Name: equipments equipments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.equipments
    ADD CONSTRAINT equipments_pkey PRIMARY KEY (equipmentid);


--
-- Name: pricechangemessages pricechangemessages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricechangemessages
    ADD CONSTRAINT pricechangemessages_pkey PRIMARY KEY (messageid);


--
-- Name: transactions transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_pkey PRIMARY KEY (transactionid);


--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (userid);


--
-- Name: users users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- Name: walletrecords walletrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.walletrecords
    ADD CONSTRAINT walletrecords_pkey PRIMARY KEY (recordid);


--
-- Name: equipments equipment_inactive_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER equipment_inactive_trigger AFTER UPDATE OF status ON public.equipments FOR EACH ROW EXECUTE FUNCTION public.remove_from_cart_on_inactive();


--
-- Name: equipments equipment_price_change_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER equipment_price_change_trigger AFTER UPDATE OF price ON public.equipments FOR EACH ROW EXECUTE FUNCTION public.price_change_notify();


--
-- Name: transactions transaction_complete_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER transaction_complete_trigger AFTER INSERT ON public.transactions FOR EACH ROW WHEN (((new.status)::text = 'completed'::text)) EXECUTE FUNCTION public.process_completed_transaction();


--
-- Name: cart cart_equipmentid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cart
    ADD CONSTRAINT cart_equipmentid_fkey FOREIGN KEY (equipmentid) REFERENCES public.equipments(equipmentid);


--
-- Name: cart cart_userid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cart
    ADD CONSTRAINT cart_userid_fkey FOREIGN KEY (userid) REFERENCES public.users(userid);


--
-- Name: equipments equipments_sellerid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.equipments
    ADD CONSTRAINT equipments_sellerid_fkey FOREIGN KEY (sellerid) REFERENCES public.users(userid);


--
-- Name: pricechangemessages pricechangemessages_equipmentid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricechangemessages
    ADD CONSTRAINT pricechangemessages_equipmentid_fkey FOREIGN KEY (equipmentid) REFERENCES public.equipments(equipmentid);


--
-- Name: pricechangemessages pricechangemessages_userid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricechangemessages
    ADD CONSTRAINT pricechangemessages_userid_fkey FOREIGN KEY (userid) REFERENCES public.users(userid);


--
-- Name: transactions transactions_buyerid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_buyerid_fkey FOREIGN KEY (buyerid) REFERENCES public.users(userid);


--
-- Name: transactions transactions_equipmentid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_equipmentid_fkey FOREIGN KEY (equipmentid) REFERENCES public.equipments(equipmentid);


--
-- Name: transactions transactions_sellerid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_sellerid_fkey FOREIGN KEY (sellerid) REFERENCES public.users(userid);


--
-- Name: walletrecords walletrecords_transactionid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.walletrecords
    ADD CONSTRAINT walletrecords_transactionid_fkey FOREIGN KEY (transactionid) REFERENCES public.transactions(transactionid);


--
-- Name: walletrecords walletrecords_userid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.walletrecords
    ADD CONSTRAINT walletrecords_userid_fkey FOREIGN KEY (userid) REFERENCES public.users(userid);


--
-- PostgreSQL database dump complete
--

